Database Size and Allocated Space Feed

The database size and allocated space feed provides detailed information regarding the size and space allocation for a given database. The feed contains one entry with database-level information and a separate entry for each data file and log file. Filegroups, by default, are excluded.

The database level entry provides the following information:

Database size: The size of all database files.
Data files size: The size of all data files.
Log files size: The size of all log files.
Reserved space: Total space reserved for the database.
Unallocated space: The amount of space that has not been allocated.
Total space used: The total amount of space that has been used.
Space used for data: The amount of space allocated for data only.
Space used by indexes: The amount of space allocated for indexes.
Unused space: The portion of the allocated space not being used for the data or the indexes.
Space allocation: A graphical representation of the space used as a % of data files.

You can customize the feed database item via the web.config parameter DatabaseSizeFeedDatabaseItem.

The data file / log file feed items provide the following information:

Autogrowth enabled: Indicates whether the autogrowth has been enabled for this file.
Max size: The maximum size this file will be allowed to grow to.
Space reserved: Total space reserved for this file.
Space used: The total amount of space that has been used by this file.
Space allocation: A graphical representation of the space used / unused.

You can customize the log and data file item of the feed via two web.config parameters DatabaseSizeFeedDataFileItem and DatabaseSizeFeedLogFileItem.

By default, the database feed does not include filegroups. If you wish to include filegroups, specify some of the predefined filegroup fields in the web.config parameter DatabaseSizeFeedFileGroupItem.